SUPPORT / SAMPLES & SAS NOTES
Problem Note 63718: You encounter slow performance when you use SAS® Federation Server to read in SAS® data sets
 |  |  |  |  |
When you read SAS data sets using SAS Federation Server, you might encounter slow performance.
Click the Hot Fix tab in this note to access the hot fix for this issue.
After you install this hot fix, you can use the following new LIBNAME options to improve performance:
- PREFETCH=x
This option enables or disables the PreFetch capability. It is optional but is required to enable PreFetch.
0 | OFF | FALSE | NO or not specified: These turn off PreFetch.
1 | ON | TRUE | YES: These use the default value, which currently is 4.
[If you use any other unsigned integer]: The maximum number of client-side prefetch rowsets to cache.
The minimum is 2, the maximum is 32, and the default is 4. - SERVERPREFETCH=x
This option enables or disables the server-side PreFetch capability. It is optional and is valid only when you specify PREFETCH=.
Not specified: Uses the PREFETCH= (client-side) value.
0 | OFF | FALSE | NO: These disable the server-side PreFetch capability (client-side only).
1 | ON | TRUE | YES: These use the default, which currently is 4.
[If you use any other unsigned integer]: The maximum number of server-side prefetch rowsets to cache.
The minimum is 2, the maximum is 32, and the default is 4. - PREFETCHROWS=x
This setting is the suggested number of rows for the server-side prefetch rowset.
This setting is optional.
The minimum is 10, and the maximum is 10,000. - PREFETCHBYTES=x
This setting is the suggested number of bytes for the server-side prefetch rowset.
This setting is optional.
The minimum is 200 KB, and the maximum is 2 MB.
Here is an example of a SAS Federation Server LIBNAME statement that uses these options:
/* A simple connection to enable PREFETCH on both the client and the server */
/* using a default number of prefetch rowsets and a default row-array size. */
libname A fedsvr readbuff=500 noprompt="driver=remts;server=localhost;port=24141;uid=sasfedadm@saspw;pwd=xxx;conopts=(dsn=base); prefetch=true;";
/* A connection to enable PREFETCH on both the client and the server */
/* using 3 prefetch rowsets (client), */
/* 6 prefetch rowsets (server), and 2,000 prefetch rows per rowset. */
libname B fedsvr readbuff=500 noprompt="driver=remts;server=localhost;port=24141;uid=sasfedadm@saspw;pwd=xxx;conopts=(dsn=base); prefetch=3;serverprefetch=6;prefetchrows=2000";
/* using a default number of prefetch rowsets and a default row-array size. */
libname A fedsvr readbuff=500 noprompt="driver=remts;server=localhost;port=24141;uid=sasfedadm@saspw;pwd=xxx;conopts=(dsn=base); prefetch=true;";
/* A connection to enable PREFETCH on both the client and the server */
/* using 3 prefetch rowsets (client), */
/* 6 prefetch rowsets (server), and 2,000 prefetch rows per rowset. */
libname B fedsvr readbuff=500 noprompt="driver=remts;server=localhost;port=24141;uid=sasfedadm@saspw;pwd=xxx;conopts=(dsn=base); prefetch=3;serverprefetch=6;prefetchrows=2000";
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Federation Server | Microsoft® Windows® for x64 | 4.2 | 4.2 | 9.4 TS1M5 | 9.4 TS1M6 |
| Linux for x64 | 4.2 | 4.2 | 9.4 TS1M5 | 9.4 TS1M6 | ||